<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/temp.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>temp</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.STYLE1 {font-family: Arial, Helvetica, sans-serif}
-->
</style>
<!-- InstanceEndEditable -->
<style type="text/css">
<!--
.STYLE3 {font-family: Arial, Helvetica, sans-serif}
.STYLE4 {font-size: 10px}
.STYLE7 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; }
.STYLE8 {color: #6C0101}
-->
</style>
</head>

<body  style="background-image:url(../images/websitebackgrund.png);">
<table width="802" border="0">
  <tr>
  <td width="178" ><a href="index.php" class="STYLE7"><img src="../images/logo.jpg" alt="Home Page" width="141" height="126" border="0" /></a></td>
    <td width="130"><a href="index.php" class="STYLE7">User Login</a> </td>
	<td width="159"><a href="superUserLogin.php" class="STYLE7">Super User Login</a> </td>
    <td width="157"><a href="managerLogin.php" class="STYLE7">Manager Login</a> </td>
    <td width="156"><a href="adminLogin.php" class="STYLE7">Adminster Login</a> </td>
  </tr>
</table>
<!-- InstanceBeginEditable name="EditRegion" -->
<?php 
    include ("../Connections/cpsms.php");
 	$query = "select * from users;";
	$sql = mysql_query($query) or die(mysql_error());
	$array = mysql_fetch_array($sql);

?>
<table width="888" border="0">
<tr>
    <td width="178" height="23">&nbsp;</td>
    <td width="533">&nbsp;</td>
    <td width="74"><form id="form5" name="form5" method="post" action="">
        <div align="right">
          <input type="submit" name="Submit5" value="Retrival" />
        </div>
    </form></td>
    <td width="21">&nbsp;</td>
    <td width="26">&nbsp;</td>
    <td width="58"><form id="form4" name="form4" method="post" action="superUserLogin.php">
      <div align="right">
        <input type="submit" name="Submit42" value="Cancel" />
      </div>
    </form></td>
</tr>
  <tr>
    <td colspan="6"><table width="911" height="24" border="1" cellspacing="0">
      <tr>
        <td width="53" height="22" class="STYLE1" >Police ID</td>
        <td width="86" class="STYLE1" >Archive name</td>
        <td width="43" class="STYLE1" >Gender</td>
        <td width="62" class="STYLE1" >DOB</td>
        <td width="31" class="STYLE1" >Rank</td>
        <td width="70" class="STYLE1" >Birth place</td>
        <td width="39" class="STYLE1" >Ethic</td>
        <td width="86" class="STYLE1">Political Back</td>
        <td width="101" class="STYLE1">Current  Position</td>
        <td width="72" class="STYLE1" >Archive No</td>
        <td width="105" class="STYLE1" >Police WorkDate</td>
        <td width="39" class="STYLE1" >details</td>
      </tr>
      <?PHP
   while($array){
      $archiveid = $array['Archiveid'];
      $birthplace = $array['Birthplace'];
      $CurrentPosition = $array['CurrentPosition'];
      $DOB = $array['DOB'];
      $Ethic = $array['Ethic'];
	  $FirstEducation = $array['FirstEducation'];
      $HighestAcademicInstitution = $array['HighestAcademicInstitution'];
      $HighestEducation = $array['HighestEducation'];
      $loginname = $array['loginname'];
      $PartyDate = $array['PartyDate'];
	  $loginpassword = $array['loginpassword'];
      $photo = $array['photo'];
      $PoliceIDNo = $array['PoliceIDNo'];
      $PoliceWorkDate = $array['PoliceWorkDate'];
      $Political = $array['Political'];
      $Rank = $array['Rank'];
	  $username = $array['username'];
	  $WorkDate = $array['WorkDate'];
	  
	  if($array['Gender'] == 1)
	  {$Gender = "Mail";}
	  else if($array['Gender'] == 0)
	  {$Gender = "Femail";}
	  else 
	  {$Gender = "";}

      echo ("<tr><td>" .$PoliceIDNo ."</td><td>" .$username ."</td><td>" .$Gender ."</td><td>" .$DOB ."</td><td>" .$Rank ."</td><td>" .$birthplace.'$' ."</td><td>" .$Ethic ."</td><td>" .$Political ."</td><td>" .$CurrentPosition ."</td><td>" ."PC".$archiveid ."</td><td>" .$WorkDate ."</td><td ><a href='UserdetailsforSuper.php?id=".$archiveid ."'>details</a></td></tr>");
      $array = mysql_fetch_array($sql);
   }
?>
    </table></td>-  </tr>
  <tr>
    <td colspan="6"><table width="346" border="0" align="right">
      <tr>
        <td width="146" height="25">&nbsp;</td>
        <td width="72"><form id="form5" name="form5" method="post" action="">
            
              <div align="right">
                <input type="submit" name="Submit5" value="Retrival" />
              </div>
        </form></td>
        <td width="24"><div align="right"></div></td>
        <td width="24"><div align="right"></div></td>
        <td width="58"><form id="form4" name="form4" method="post" action="superUserLogin.php">
            
              <div align="right">
                <input type="submit" name="Submit4" value="Cancel" />
              </div>
        </form></td>
      </tr>
    </table></td>
  </tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<!-- InstanceEndEditable --> <div class="STYLE3 STYLE4" style="background:#51A2B9">Copyright 2009_CP3046_G24   | E-mail:<a href="mailto:xiaoguang.bian@gmail.com">xiaoguang.bian@gmail.com</a> | Address: BJUT,chaoyangqu 100,Beijing. 10022
</div>
</body>
<!-- InstanceEnd --></html>
